home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software Vault: The Gold Collection
/
Software Vault - The Gold Collection (American Databankers) (1993).ISO
/
cdr11
/
pdox693.zip
/
TI619.ASC
< prev
next >
Wrap
Text File
|
1992-08-12
|
3KB
|
133 lines
PRODUCT : Paradox NUMBER : 619
VERSION : 3.5 & up
OS : DOS
DATE : August 12, 1992 PAGE : 1/2
TITLE : Creating and using PAL variables in reports and forms
Using PAL variables in reports and forms is a feature available
to Paradox version 3.5 and above. Variables can be placed in a
report or form while in the report or form design mode. The
steps are as follows:
o From the Paradox main menu, choose {Report} {Change} or
{Form} {Change}.
o Select the appropriate table and report or form number.
o Press <F10> and select {Field} {Place} {Calculated}.
o You may now type in a memory variable or a calculation
which uses variables (eg. VAR where "VAR" is the name of
the memory variable or VAR * VAR1 where "VAR" and "VAR1"
are numeric variables involved in a calculation) and press
<Enter>, then press <F2> to save the file.
NOTE: Before printing the report or viewing the form, the memory
variables used will need to be assigned values:
One way to assign a value to a variable is through a Miniscript.
For example, here are the steps necessary to set a variable
called "VAR" to the number 400
o Press <ALT><F10> to bring up the PAL menu.
o Choose {Miniscript} from the PAL menu.
o Now type VAR = 400. The expression will set the memory
variable called "VAR" to the numeric value 400.
NOTE: Variable can also be set to calculations, text values, and
dates as in the following expressions:
o VAR1 = (100+VAR)/1000
o VAR2 = "This is a text string"
o VAR3 = 12/15/91
PRODUCT : Paradox NUMBER : 619
VERSION : 3.5 & up
OS : DOS
DATE : August 12, 1992 PAGE : 2/2
TITLE : Creating and using PAL variables in reports and forms
Additionally, a variable can be set to a value on a table. For
example, if a query with a CALC SUM is run, an Answer table is
generated with a one field record. To set the variable to that
field in the Answer table, move the cursor to the field and do a
Miniscript with the expression VAR = []. Before doing so, make
sure the cursor is in the correct field since [] refers to the
current field.
DISCLAIMER: You have the right to use this technical information
subject to the terms of the No-Nonsense License Statement that
you received with the Borland product to which this information
pertains.